Tabela LumpSumPerfContractService

Definicja tabeli LumpSumPerfContractService

Name

LumpSumPerfContractService

Code

LumpSumPerfContractService

Comment

PL: zawiera definicje wykonan pozycji z CliniNETu bez wyliczonej finalnej daty wykonania


Lista kolumn tabeli LumpSumPerfContractService

Name

Code

ContractServicePerfID

ContractServicePerfID

Status

Status

ContractNo

ContractNo

ConContractServCode

ConContractServCode

Distinction

Distinction

ContractServCode

ContractServCode

PerfServStopDT

PerfServStopDT

EventStopDT

EventStopDT

EpisodeStopDT

EpisodeStopDT

UnitPrice

UnitPrice

Points

Points

NfzOrgUnitCode

NfzOrgUnitCode

NfzOrgUnitName

NfzOrgUnitName

OrgUnitCode

OrgUnitCode

OrgUnitName

OrgUnitName


Kolumna ContractServicePerfID tabeli LumpSumPerfContractService

Definicja kolumny ContractServicePerfID tabeli LumpSumPerfContractService

Name

ContractServicePerfID

Code

ContractServicePerfID

Data Type

NUMBER(10)

Mandatory

No

Comment

id wykonania PCS


Kolumna Status tabeli LumpSumPerfContractService

Definicja kolumny Status tabeli LumpSumPerfContractService

Name

Status

Code

Status

Data Type

NUMBER(10)

Mandatory

No

Comment

status pozycji rozl.


Kolumna ContractNo tabeli LumpSumPerfContractService

Definicja kolumny ContractNo tabeli LumpSumPerfContractService

Name

ContractNo

Code

ContractNo

Data Type

VARCHAR2(50)

Mandatory

Yes

Comment

numer umowy


Kolumna ConContractServCode tabeli LumpSumPerfContractService

Definicja kolumny ConContractServCode tabeli LumpSumPerfContractService

Name

ConContractServCode

Code

ConContractServCode

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

kod produktu kontr.


Kolumna Distinction tabeli LumpSumPerfContractService

Definicja kolumny Distinction tabeli LumpSumPerfContractService

Name

Distinction

Code

Distinction

Data Type

NUMBER(10)

Mandatory

No

Comment

wyróznik


Kolumna ContractServCode tabeli LumpSumPerfContractService

Definicja kolumny ContractServCode tabeli LumpSumPerfContractService

Name

ContractServCode

Code

ContractServCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod produktu jedn.


Kolumna PerfServStopDT tabeli LumpSumPerfContractService

Definicja kolumny PerfServStopDT tabeli LumpSumPerfContractService

Name

PerfServStopDT

Code

PerfServStopDT

Data Type

DATE

Mandatory

No

Comment

data wykonania


Kolumna EventStopDT tabeli LumpSumPerfContractService

Definicja kolumny EventStopDT tabeli LumpSumPerfContractService

Name

EventStopDT

Code

EventStopDT

Data Type

DATE

Mandatory

No

Comment

data konca eventu


Kolumna EpisodeStopDT tabeli LumpSumPerfContractService

Definicja kolumny EpisodeStopDT tabeli LumpSumPerfContractService

Name

EpisodeStopDT

Code

EpisodeStopDT

Data Type

DATE

Mandatory

No

Comment

data konca episodu


Kolumna UnitPrice tabeli LumpSumPerfContractService

Definicja kolumny UnitPrice tabeli LumpSumPerfContractService

Name

UnitPrice

Code

UnitPrice

Data Type

NUMBER(19,4)

Mandatory

No

Comment

cena za punkt


Kolumna Points tabeli LumpSumPerfContractService

Definicja kolumny Points tabeli LumpSumPerfContractService

Name

Points

Code

Points

Data Type

NUMBER(15,4)

Mandatory

No

Comment

liczba punktów


Kolumna NfzOrgUnitCode tabeli LumpSumPerfContractService

Definicja kolumny NfzOrgUnitCode tabeli LumpSumPerfContractService

Name

NfzOrgUnitCode

Code

NfzOrgUnitCode

Data Type

VARCHAR2(32)

Mandatory

Yes

Comment

kod NFZ komórki wyk.


Kolumna NfzOrgUnitName tabeli LumpSumPerfContractService

Definicja kolumny NfzOrgUnitName tabeli LumpSumPerfContractService

Name

NfzOrgUnitName

Code

NfzOrgUnitName

Data Type

VARCHAR2(255)

Mandatory

Yes

Comment

nazwa NFZ komórki wyk.


Kolumna OrgUnitCode tabeli LumpSumPerfContractService

Definicja kolumny OrgUnitCode tabeli LumpSumPerfContractService

Name

OrgUnitCode

Code

OrgUnitCode

Data Type

VARCHAR2(32)

Mandatory

No

Comment

kod jednostki wyk.


Kolumna OrgUnitName tabeli LumpSumPerfContractService

Definicja kolumny OrgUnitName tabeli LumpSumPerfContractService

Name

OrgUnitName

Code

OrgUnitName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

nazwa jednostki wyk.